Release 10.1A: OpenEdge Data Management:
SQL Reference

SQLCursor.getParam

Retrieves the values of Java OUT and INOUT parameters.

Format

inout_var = getParam( int fieldIndex, short fieldType ) ;

Returns

OUT or INOUT variable

Parameters

inout_var

The target variable into which the value of an OUT or INOUT parameter is stored.

fieldIndex

An integer that specifies the position of the parameter in the parameter list.

fieldType

A short integer that specifies the data type of the parameter. The allowable defined values for fieldType are listed in Table 55, grouped by category of data type.

Table 55: Allowable values for fieldType in getParam 

Character	Exact numeric	Approximate numeric	Date-time	Bit string
CHAR	INTEGER	REAL	DATE	BIT
CHARACTER	SMALLINT	FLOAT	TIME	BINARY
VARCHAR	TINYINT	DOUBLE	TIMESTAMP	VARBINARY
–	NUMERIC	–	–	LVARBINARY
–	DECIMAL	–	–	–

Throws

DhSQLException

Notes

The getParam() method returns the value of an INOUT or OUT parameter identified by the number you specify in the fieldIndex parameter. getParam() returns the value as an object of the data type you specify in the fieldType parameter. Since getParam() returns the result as an instance of class Object, you must explicitly cast your inout_var variable to the correct data type.
If the OUT or INOUT parameter is of data type CHARACTER, then getParam returns a Java String Object. You must declare a procedure variable of type String, and explicitly cast the value returned by getParam to type String. Before calling getParam() you must call the SQLCursor.wasNULL method to test whether the returned value is NULL. If getParam() is called for a NULL value, it raises a DhSQLException.